<%@page contentType="text/html; charset=utf-8"%>
<%
response.setHeader("Content-type","application/vnd.ms-excel");
response.setHeader("Content-Disposition","filename=BusinessBillList.xls");
%>
<%@ include file="../inc/TagLibs.jsp"%>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>kekewu</o:Author>
  <o:LastAuthor>kekewu</o:LastAuthor>
  <o:Created>2008-06-06T23:46:55Z</o:Created>
  <o:LastSaved>2008-06-06T23:50:44Z</o:LastSaved>
  <o:Company>home</o:Company>
  <o:Version>11.8107</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:1.0in .75in 1.0in .75in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;}
tr
	{mso-height-source:auto;
	mso-ruby-visibility:none;}
col
	{mso-width-source:auto;
	mso-ruby-visibility:none;}
br
	{mso-data-placement:same-cell;}
.style0
	{mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	white-space:nowrap;
	mso-rotate:0;
	mso-background-source:auto;
	mso-pattern:auto;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	border:none;
	mso-protection:locked visible;
	mso-style-name:常规;
	mso-style-id:0;}
td
	{mso-style-parent:style0;
	padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:windowtext;
	font-size:12.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:middle;
	border:none;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-protection:locked visible;
	white-space:nowrap;
	mso-rotate:0;}
.xl24
	{mso-style-parent:style0;
	mso-number-format:"Short Date";}
.xl25
	{mso-style-parent:style0;
	font-weight:700;
	text-align:center;}
.xl26
	{mso-style-parent:style0;
	text-align:left;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:9.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:宋体;
	mso-generic-font-family:auto;
	mso-font-charset:134;
	mso-char-type:none;
	display:none;}
-->
</style>
<!--[if gte mso 9]><xml>
 <x:ExcelWorkbook>
  <x:ExcelWorksheets>
   <x:ExcelWorksheet>
    <x:Name>Sheet1</x:Name>
    <x:WorksheetOptions>
     <x:DefaultRowHeight>285</x:DefaultRowHeight>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>3</x:ActiveRow>
       <x:ActiveCol>7</x:ActiveCol>
      </x:Pane>
     </x:Panes>
     <x:ProtectContents>False</x:ProtectContents>
     <x:ProtectObjects>False</x:ProtectObjects>
     <x:ProtectScenarios>False</x:ProtectScenarios>
    </x:WorksheetOptions>
   </x:ExcelWorksheet>
  </x:ExcelWorksheets>
  <x:WindowHeight>9135</x:WindowHeight>
  <x:WindowWidth>11715</x:WindowWidth>
  <x:WindowTopX>240</x:WindowTopX>
  <x:WindowTopY>60</x:WindowTopY>
  <x:ProtectStructure>False</x:ProtectStructure>
  <x:ProtectWindows>False</x:ProtectWindows>
 </x:ExcelWorkbook>
</xml><![endif]-->
</head>

<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=896 style='border-collapse:collapse;table-layout:fixed;width:674pt'>
 <col width=109 style='mso-width-source:userset;mso-width-alt:3488;width:82pt'>
 <col width=101 style='mso-width-source:userset;mso-width-alt:3232;width:76pt'>
 <col width=149 style='mso-width-source:userset;mso-width-alt:4768;width:112pt'>
 <col width=101 style='mso-width-source:userset;mso-width-alt:3232;width:76pt'>
 <col width=85 span=3 style='mso-width-source:userset;mso-width-alt:2720;width:64pt'>
 <col width=101 style='mso-width-source:userset;mso-width-alt:3232;width:76pt'>
 <col width=80 style='mso-width-source:userset;mso-width-alt:2700;width:60pt'>
 <tr height=39 style='mso-height-source:userset;height:29.25pt'>
  <td colspan=9 height=39 class=xl25 width=903 style='height:29.25pt;width:678pt'>销售回款一览表</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td colspan=9 height=19 class=xl26 style='height:14.25pt'>
  	回款合计：${total}元（预付：${imprestTotal}元  结欠：${receiveTotal}元）
  </td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td colspan=9 height=19 class=xl26 style='height:14.25pt'>预付款</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 style='height:14.25pt'>回款日期</td>
  <td>单号</td>
  <td colspan="2">付款单位</td>
  <td>金额</td>
  <td>银行账号</td>
  <td>经办人</td>
  <td>开单人</td>
  <td>部门</td>
 </tr>
 <c:forEach var="item" items="${imprestList}">
 <tr height=19 style='height:14.25pt'>
  <td height=19 style='height:14.25pt'><fmt:formatDate value="${item[0].businessBill.orderDate}" pattern="yyyy-MM-dd"/></td>
  <td>${item[0].businessBill.billCode}</td>
  <td colspan="2">${item[1].estName}<c:if test="${item[0].businessBill.linkman!=null && item[0].businessBill.linkman!=''}">(${item[0].businessBill.linkman})</c:if></td>
  <td align=right x:num>${item[0].businessBill.imprest}</td>
  <td><commonTag:showSimpleObjectName list="${bankAccountList}" objectId="${item[0].businessBill.bankAccountId}" /></td>
  <td>${item[0].businessBill.managerName}</td>
  <td>${item[0].businessBill.createrName}</td>
  <td>${item[0].departmentName}</td>
 </tr>
 </c:forEach>
 <tr height=19 style='height:14.25pt'>
  <td colspan=9 height=19 class=xl26 style='height:14.25pt'></td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td colspan=9 height=19 class=xl26 style='height:14.25pt'>付款</td>
 </tr>
 <tr height=19 style='height:14.25pt'>
  <td height=19 style='height:14.25pt'>回款日期</td>
  <td>单号</td>
  <td colspan="2">付款单位</td>
  <td>金额</td>
  <td>银行账号</td>
  <td>经办人</td>
  <td>开单人</td>
  <td>部门</td>
 </tr>
 <c:forEach var="item" items="${receiveList}">
 <tr height=19 style='height:14.25pt'>
  <td height=19 style='height:14.25pt'><fmt:formatDate value="${item[0].receiveBill.receiveDate}" pattern="yyyy-MM-dd"/></td>
  <td>${item[0].receiveBill.billCode}</td>
  <td colspan="2">${item[1].estName}</td>
  <td align=right x:num>${item[0].receiveBill.cost}</td>
  <td><commonTag:showSimpleObjectName list="${bankAccountList}" objectId="${item[0].receiveBill.bankAccountId}" /></td>
  <td>${item[0].receiveBill.managerName}</td>
  <td>${item[0].receiveBill.createrName}</td>
  <td>${item[0].departmentName}</td>
 </tr>
 </c:forEach>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=109 style='width:82pt'></td>
  <td width=101 style='width:76pt'></td>
  <td width=149 style='width:112pt'></td>
  <td width=101 style='width:76pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=101 style='width:76pt'></td>
  <td width=80 style='width:60pt'></td>
 </tr>
 <![endif]>
</table>

</body>

</html>
